/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50615
 Source Host           : localhost
 Source Database       : pcms

 Target Server Type    : MySQL
 Target Server Version : 50615
 File Encoding         : utf-8

 Date: 05/24/2015 18:21:52 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `ycus_notification_center`
-- ----------------------------
DROP TABLE IF EXISTS `ycus_notification_center`;
CREATE TABLE `ycus_notification_center` (
  `nid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '消息编号',
  `uid` int(8) NOT NULL COMMENT '消息归属用户编号',
  `notice_time` int(11) NOT NULL COMMENT '提醒时间',
  `notice_message` varchar(500) NOT NULL COMMENT '提醒内容',
  `notice_state` tinyint(1) DEFAULT NULL COMMENT '消息状态',
  PRIMARY KEY (`nid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `ycus_notification_center`
-- ----------------------------
BEGIN;
INSERT INTO `ycus_notification_center` VALUES ('1', '1', '1432449380', '快来吃饭了', '0');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
